{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":110,"n_cols":10,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Quadro do Projecto Hotel"]
[null,"Ex. 5.9 - Sim. Projecto Hotel ",null,null,null,null,null,"(100 Runs)"]
[]
[null,null,"Tx Actualização",null,{"$f":"0.1","v":0.1}]
[null,null,"NPV(0,1) - Mil €",null,{"$f":"NPV(E5,F13:F20)","v":517.70837416122686},null,null,"Run","NPV - Mil €","TIR - %"]
[null,null,"IRR (%)",null,{"$f":"IRR(F13:F20)*100","v":14.027986855508413},null,null,"Média",{"$f":"AVERAGE(I10:I110)","v":569.64653771592316},{"$f":"AVERAGE(J10:J110)","v":13.691916840504426}]
[null,null,null,null,null,null,null,"D. Padrão (*)",{"$f":"STDEV(I10:I110)","v":834.70282243452539},{"$f":"STDEV(J10:J110)","v":6.1468561860984723}]
[]
[null,null,null,null,null,null,null,null,{"$f":"+E6","v":517.70837416122686},{"$f":"+E7","v":14.027986855508413}]
[null,null,null,null,null,null,null,1,452.60443405038893,13.849137158411672]
[null,"Ano",null,"Cash - Flow (Mil €)",null,"Gerado",null,{"$f":"+H11+1","v":2},2117.282881436568,23.70045404794201]
[null,0,"Normal(μ;σ)",-800,null,{"$f":"+D13","v":-800},null,{"$f":"+H12+1","v":3},494.67427446161514,13.84919772891684]
[null,1,"Normal(μ;σ)",-800,50,{"$f":"NORMINV(RAND(),D14,E14)","v":-831.06616692099703},null,4,-558.85466514746872,4.2788598274231759]
[null,2,"Normal(μ;σ)",-800,100,-853.10308282673873,null,5,113.12056783283877,10.968762506381257]
[null,3,"Normal(μ;σ)",-700,150,-705.21045334462588,null,6,574.31933312281376,14.346793932264191]
[null,4,"Normal(μ;σ)",300,200,400.89372437403722,null,7,1845.4790015633553,21.770869499572164]
[null,5,"Normal(μ;σ)",400,200,377.17859940018036,null,8,337.5129986499004,12.775512492733032]
[null,6,"Normal(μ;σ)",500,200,662.44828336603655,null,9,-567.73261646632773,4.5966055503592562]
[null,7,"Uniforme(a;b",2000,8440,{"$f":"+D20+RAND()*(E20-D20)","v":4828.772873978487},null,10,819.81009472470339,15.89229087984334]
[null,null,null,null,null,null,null,11,1104.3891438216983,17.641417240648714]
[null,null,null,null,null,null,null,12,-146.47136977121403,8.49364129993997]
[null,null,null,null,null,null,null,13,2434.1339734550552,25.608168210785397]
[null,"Intervalo de Confiança a ",null,0.95,null,null,null,14,447.3719858508058,13.59426375693813]
[null,null,null,null,null,null,null,15,-381.97651257835679,6.5136241048700638]
[null,"NPV",null,null,"IRR",null,null,16,684.36622098668522,15.443965249415669]
[null,"L. Inferior","L. Superior",null,"L. Inferior","L. Superior",null,17,1838.2022537338528,23.34732257493539]
[null,null,null,null,null,null,null,18,-319.35782388503947,7.1262664475999715]
[null,{"$f":"+$I$7-$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":404.02338873476197},{"$f":"+$I$7+$I$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":735.26968669708435},null,{"$f":"+$J$7-$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":12.472247216162383},{"$f":"+$J$7+$J$8/SQRT($H$110)*TINV(1-$D$24,$H$110-1)","v":14.911586464846469},null,19,993.26915281547485,17.793970528260772]
[null,null,null,null,null,null,null,20,-1015.1184956519535,-0.80487365298018698]
[null,null,null,null,null,null,null,21,604.37647290361588,14.944614009015655]
[null,"(*) O Excel já dá o Desvio Padrão Corrigido.",null,null,null,null,null,22,648.96230520247354,15.068401941461484]
[null,null,null,null,null,null,null,23,276.76079885838317,12.293116296526762]
[null,null,null,null,null,null,null,24,1326.4643270117472,19.437686877012638]
[null,null,null,null,null,null,null,25,370.1960356309167,13.014033708408878]
[null,null,null,null,null,null,null,26,-274.56660695297734,7.1365166546632608]
[null,null,null,null,null,null,null,27,-213.53039994700359,8.1528119254811848]
[null,null,null,null,null,null,null,28,1402.3929511636707,19.994893145954663]
[null,null,null,null,null,null,null,29,1507.3817105180779,19.843290093693923]
[null,null,null,null,null,null,null,30,1957.9879554285769,22.665996175790838]
[null,null,null,null,null,null,null,31,753.68081200608765,15.572757470603694]
[null,null,null,null,null,null,null,32,-104.80219946129947,9.0961119224449938]
[null,null,null,null,null,null,null,33,1444.7531039613534,19.895429333289361]
[null,null,null,null,null,null,null,34,-477.62951655534107,5.316676959916844]
[null,null,null,null,null,null,null,35,438.036444864977,13.408937318354663]
[null,null,null,null,null,null,null,36,771.94942719645655,15.484989517404291]
[null,null,null,null,null,null,null,37,1784.8177819745706,22.422581114347008]
[null,null,null,null,null,null,null,38,870.5071078807207,16.471457361522134]
[null,null,null,null,null,null,null,39,580.93344021276516,14.717752805174133]
[null,null,null,null,null,null,null,40,-572.84683336241596,4.6443354670758108]
[null,null,null,null,null,null,null,41,-1135.1113288473023,-1.9270246694176985]
[null,null,null,null,null,null,null,42,322.32346902259405,12.379372638948327]
[null,null,null,null,null,null,null,43,614.44331142702674,14.908457716758971]
[null,null,null,null,null,null,null,44,1113.52053990783,17.890793495443447]
[null,null,null,null,null,null,null,45,1001.5081300901599,17.113132265675969]
[null,null,null,null,null,null,null,46,1295.6197637911405,18.540186960598714]
[null,null,null,null,null,null,null,47,-378.64879184935506,6.4299326615803176]
[null,null,null,null,null,null,null,48,182.92789451312376,11.665370069635506]
[null,null,null,null,null,null,null,49,1607.1689304580534,20.536905538941742]
[null,null,null,null,null,null,null,50,1382.4992224613129,18.746516668875302]
[null,null,null,null,null,null,null,51,-967.69910587383356,0.2227783946230355]
[null,null,null,null,null,null,null,52,-75.44824375137253,9.3757992487003996]
[null,null,null,null,null,null,null,53,957.21267784051918,17.319116309862782]
[null,null,null,null,null,null,null,54,428.45983259559694,13.795108069584327]
[null,null,null,null,null,null,null,55,-340.85635412606814,6.9268888714768106]
[null,null,null,null,null,null,null,56,698.79650303701897,15.308567001125283]
[null,null,null,null,null,null,null,57,71.562713382782022,10.575050356551664]
[null,null,null,null,null,null,null,58,-611.15031183122107,3.8343414226215566]
[null,null,null,null,null,null,null,59,-243.9918631658615,7.9150650728826655]
[null,null,null,null,null,null,null,60,1109.1879494449438,18.001698965889634]
[null,null,null,null,null,null,null,61,421.18989159425212,13.447799702647046]
[null,null,null,null,null,null,null,62,567.36982040070745,14.155360018308127]
[null,null,null,null,null,null,null,63,1856.9685998217888,22.083681872449603]
[null,null,null,null,null,null,null,64,-473.11267227821457,5.2888238339745097]
[null,null,null,null,null,null,null,65,-285.96608077958882,7.4136729888557129]
[null,null,null,null,null,null,null,66,-501.95725141708095,5.3368108297393135]
[null,null,null,null,null,null,null,{"$f":"+H76+1","v":67},1838.1738311872964,21.85530978497394]
[null,null,null,null,null,null,null,68,1251.0816201663977,19.931047431569237]
[null,null,null,null,null,null,null,69,-535.71631322063593,5.050326446094533]
[null,null,null,null,null,null,null,70,742.3881216418464,15.561608278800598]
[null,null,null,null,null,null,null,71,-394.26718284536014,6.4343428415903903]
[null,null,null,null,null,null,null,72,-305.9412486557531,7.2145667510650435]
[null,null,null,null,null,null,null,73,313.50109727822775,12.357554362228317]
[null,null,null,null,null,null,null,74,1857.8749326407051,21.478071589175297]
[null,null,null,null,null,null,null,75,1160.828456740669,18.082096260340141]
[null,null,null,null,null,null,null,76,1602.3070126461355,19.904278529851172]
[null,null,null,null,null,null,null,77,500.34799183055009,13.795010705619305]
[null,null,null,null,null,null,null,78,133.8853320748438,11.040651353173603]
[null,null,null,null,null,null,null,79,62.529466904572097,10.606835867211828]
[null,null,null,null,null,null,null,80,454.51974803104304,13.468564605713397]
[null,null,null,null,null,null,null,81,978.40439025079695,16.948492666263036]
[null,null,null,null,null,null,null,82,1948.9770133973705,22.356397470007082]
[null,null,null,null,null,null,null,83,1281.4466090885776,19.1949006669625]
[null,null,null,null,null,null,null,84,1644.1250459397938,21.614122541464774]
[null,null,null,null,null,null,null,85,66.956094282135453,10.580549527037796]
[null,null,null,null,null,null,null,86,266.34475234517714,12.388673799288007]
[null,null,null,null,null,null,null,87,-138.47827318122239,8.6535953095437499]
[null,null,null,null,null,null,null,88,-586.04529174531774,4.0980414938801557]
[null,null,null,null,null,null,null,89,-36.798495350262989,9.6261983507670568]
[null,null,null,null,null,null,null,90,1849.7761476189141,21.641772288504455]
[null,null,null,null,null,null,null,91,2134.7842392606699,24.784045280163134]
[null,null,null,null,null,null,null,92,-58.670993461297996,9.5010240162667792]
[null,null,null,null,null,null,null,93,2014.7648310300146,23.415370803449733]
[null,null,null,null,null,null,null,94,377.41438899971604,13.067887975157589]
[null,null,null,null,null,null,null,95,263.90134475538906,12.108603451765966]
[null,null,null,null,null,null,null,96,563.99928121503842,14.278532186512759]
[null,null,null,null,null,null,null,97,542.58260894192972,14.04197922545778]
[null,null,null,null,null,null,null,98,1922.0082530322484,23.478954248336059]
[null,null,null,null,null,null,null,99,10.154274476975511,10.086363057699588]
[null,null,null,null,null,null,null,100,309.7656504201334,12.556999080767683]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}